{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Nakit Akış","Haftalık Analiz","Aylık Analiz","Gruplar"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":2},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Nakit Akış","index":0,"n_rows":1045,"n_cols":15,"rows_kept":1045,"cut":false,"hidden":false,"merged":[[14,1,14,6],[9,4,9,5],[1,0,1,3],[0,0,0,3],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5]]}
["Nakit Akış Raporu"]
["2020-04-30"]
[]
[]
[null,"Başlangıç Bakiye",null,null,{"$f":"SUMIF(Nakit_Akis[Giriş/Çıkış],$B5,Nakit_Akis[Tutar])","v":100000}]
[null,"Nakit Girişleri",null,null,{"$f":"SUMIF(Nakit_Akis[Giriş/Çıkış],$B6,Nakit_Akis[Tutar])","v":720000}]
[null,"Nakit Çıkışları",null,null,{"$f":"SUMIF(Nakit_Akis[Giriş/Çıkış],$B7,Nakit_Akis[Tutar])","v":-808100}]
[null,"Kapanış Nakit",null,null,{"$f":"E5+E6+E7","v":11900}]
[]
[null,"Asgari Nakit Seviyes",null,null,100000]
[]
[]
[]
[]
[null,"Veri Girdikten sonra yukarıdaki tuşlara vas"]
[]
[]
[]
[]
[null,null,"Giriş Yap",null,null,null,null,null,null,"İşlem Türünü Seç","Taraf Gir","Açıklama Gir","Tutar Gir"]
[]
[null,"Sıra","Tarih","Gün","Hafta","Ay","Giriş/Çıkış","İşlem Grubu","Ödeme Şekli","İşlem Türü","Taraf","Açıklama","Tutar","Kontrol","Bakiye"]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":1},"2020-05-01",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":17},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":4},{"$f":"VLOOKUP(J23,Grup[#All],3,0)","v":"Başlangıç Bakiye"},{"$f":"VLOOKUP(J23,Grup[#All],2,0)","v":"Başlangıç Bakiye"},null,"Başlangıç Bakiye",null,null,100000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":100000}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":2},"2020-05-01",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":18},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J24,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J24,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","A Madencilik",null,-10000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":90000}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":3},"2020-05-04",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":19},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J25,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J25,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tahsilatlar","B İnşaat",null,25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":115000}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":4},"2020-05-04",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":19},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J26,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J26,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tahsilatlar","A Ticaret",null,10000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":125000}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":5},"2020-05-05",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":19},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J27,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J27,Grup[#All],2,0)","v":"Operasyon"},"EFT","Kira Ödemeleri","Vergi Dairesi",null,-10000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":115000}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":6},"2020-05-05",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":19},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J28,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J28,Grup[#All],2,0)","v":"Operasyon"},"EFT","Personel Ücretleri","Personel",null,-90000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":25000}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":7},"2020-05-07",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":19},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J29,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J29,Grup[#All],2,0)","v":"Operasyon"},"Nakit","Tahsilatlar","C Mimarlık",null,15000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":40000}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":8},"2020-05-07",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":19},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J30,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J30,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","C Nakliyay",null,-12500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":27500}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":9},"2020-05-07",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":19},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J31,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J31,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","D Nalburiye",null,-25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":2500}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":10},"2020-05-11",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":20},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J32,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J32,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tahsilatlar","D Peyzaj İşleri",null,15000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":17500}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":11},"2020-05-13",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":20},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J33,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J33,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","E Restorasyon",null,25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":42500}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":12},"2020-05-13",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":20},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J34,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J34,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","A Madencilik",null,-10000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":32500}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":13},"2020-05-13",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":20},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J35,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J35,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","B Madencilik",null,-12500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":20000}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":14},"2020-05-14",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":20},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J36,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J36,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","B Madencilik",null,-12500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":7500}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":15},"2020-05-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":20},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J37,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J37,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","B İnşaat",null,30000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":37500}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":16},"2020-05-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":20},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J38,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J38,Grup[#All],2,0)","v":"Operasyon"},"EFT","Elektrik / Su / Doğalgaz","D Doğalgaz Dağıtım",null,-100,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":37400}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":17},"2020-05-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":20},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J39,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J39,Grup[#All],2,0)","v":"Operasyon"},"EFT","Elektrik / Su / Doğalgaz","S Su ve Kanalizasyon",null,-300,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":37100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":18},"2020-05-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":20},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J40,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J40,Grup[#All],2,0)","v":"Operasyon"},"EFT","Sigorta Primleri","S Sigorta Acentası",null,-300,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":36800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":19},"2020-05-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":20},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J41,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J41,Grup[#All],2,0)","v":"Operasyon"},"EFT","Elektrik / Su / Doğalgaz","G Elektrik Dağıtım",null,-1000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":35800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":20},"2020-05-18",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":21},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J42,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J42,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","E Toptan Ticaret",null,-7500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":28300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":21},"2020-05-19",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":21},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J43,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J43,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tahsilatlar","C Mimarlık",null,10000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":38300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":22},"2020-05-22",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":21},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J44,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J44,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","A Ticaret",null,15000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":53300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":23},"2020-05-22",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":21},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J45,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J45,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","C Nakliyat",null,-2500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":50800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":24},"2020-05-25",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":22},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J46,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J46,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tahsilatlar","E Restorasyon",null,25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":75800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":25},"2020-05-26",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":22},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J47,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J47,Grup[#All],2,0)","v":"Operasyon"},"EFT","Muhtasar Ödemeleri","Vergi Dairesi",null,-10000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":65800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":26},"2020-05-26",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":22},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J48,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J48,Grup[#All],2,0)","v":"Operasyon"},"EFT","KDV Ödemeleri","Vergi Dairesi",null,-22500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":43300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":27},"2020-05-27",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":22},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J49,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J49,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","E Toptan Ticaret",null,-7500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":35800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":28},"2020-05-28",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":22},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J50,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J50,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","F Mühendislik",null,15000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":50800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":29},"2020-05-28",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":22},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J51,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J51,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","D Nalburiye",null,-2500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":48300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":30},"2020-05-29",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":22},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J52,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J52,Grup[#All],2,0)","v":"Operasyon"},"Kredi Kartı","Tahsilatlar","C Mimarlık",null,15000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":63300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":31},"2020-05-29",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":22},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J53,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J53,Grup[#All],2,0)","v":"Operasyon"},"EFT","SGK Ödemeleri","SGK",null,-2000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":61300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":32},"2020-05-29",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":22},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J54,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J54,Grup[#All],2,0)","v":"Finansman"},"EFT","Faiz Ödemeleri","Vergi Dairesi",null,-3000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":58300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":33},"2020-05-29",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":22},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":5},{"$f":"VLOOKUP(J55,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J55,Grup[#All],2,0)","v":"Finansman"},"EFT","Kredi Geri Ödemeleri","X Bank",null,-20000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":38300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":34},"2020-06-01",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":23},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J56,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J56,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","A Madencilik",null,-12500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":25800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":35},"2020-06-02",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":23},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J57,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J57,Grup[#All],2,0)","v":"Finasman"},"EFT","Kredi Kullanımları","X Bank",null,35000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":60800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":36},"2020-06-03",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":23},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J58,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J58,Grup[#All],2,0)","v":"Operasyon"},"Kredi Kartı","Tahsilatlar","C Mimarlık",null,30000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":90800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":37},"2020-06-03",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":23},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J59,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J59,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","C Mimarlık",null,10000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":100800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":38},"2020-06-03",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":23},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J60,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J60,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","C Nakliyay",null,-25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":75800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":39},"2020-06-04",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":23},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J61,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J61,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","E Restorasyon",null,30000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":105800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":40},"2020-06-04",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":23},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J62,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J62,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","D Nalburiye",null,-10000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":95800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":41},"2020-06-05",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":23},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J63,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J63,Grup[#All],2,0)","v":"Operasyon"},"EFT","Kira Ödemeleri","Vergi Dairesi",null,-10000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":85800}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":42},"2020-06-05",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":23},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J64,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J64,Grup[#All],2,0)","v":"Operasyon"},"EFT","Personel Ücretleri","Personel",null,-92500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":-6700}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":43},"2020-06-09",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":24},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J65,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J65,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","B İnşaat",null,15000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":8300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":44},"2020-06-12",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":24},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J66,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J66,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tahsilatlar","A Ticaret",null,15000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":23300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":45},"2020-06-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":25},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J67,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J67,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","C Mimarlık",null,25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":48300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":46},"2020-06-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":25},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J68,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J68,Grup[#All],2,0)","v":"Yatırım"},"EFT","Demirbaş Satış Tahsilatı",null,null,15000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":63300}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":47},"2020-06-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":25},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J69,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J69,Grup[#All],2,0)","v":"Operasyon"},"EFT","Elektrik / Su / Doğalgaz","D Doğalgaz Dağıtım",null,-100,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":63200}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":48},"2020-06-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":25},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J70,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J70,Grup[#All],2,0)","v":"Operasyon"},"EFT","Elektrik / Su / Doğalgaz","S Su ve Kanalizasyon",null,-300,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":62900}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":49},"2020-06-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":25},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J71,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J71,Grup[#All],2,0)","v":"Operasyon"},"EFT","Sigorta Primleri","S Sigorta Acentası",null,-300,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":62600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":50},"2020-06-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":25},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J72,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J72,Grup[#All],2,0)","v":"Operasyon"},"EFT","Elektrik / Su / Doğalgaz","G Elektrik Dağıtım",null,-1000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":61600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":51},"2020-06-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":25},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J73,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J73,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","B Madencilik",null,-7500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":54100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":52},"2020-06-18",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":25},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J74,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J74,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","E Restorasyon",null,25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":79100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":53},"2020-06-18",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":25},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J75,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J75,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","E Toptan Ticaret",null,-2500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":76600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":54},"2020-06-22",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":26},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J76,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J76,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tahsilatlar","B İnşaat",null,25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":101600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":55},"2020-06-22",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":26},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J77,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J77,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","C Nakliyat",null,-12500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":89100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":56},"2020-06-24",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":26},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J78,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J78,Grup[#All],2,0)","v":"Operasyon"},"Kredi Kartı","Tahsilatlar","A Ticaret",null,20000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":109100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":57},"2020-06-24",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":26},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J79,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J79,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","D Nalburiye",null,-10000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":99100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":58},"2020-06-26",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":26},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J80,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J80,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","E Restorasyon",null,25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":124100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":59},"2020-06-26",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":26},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J81,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J81,Grup[#All],2,0)","v":"Operasyon"},"EFT","Muhtasar Ödemeleri","Vergi Dairesi",null,-12000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":112100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":60},"2020-06-26",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":26},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J82,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J82,Grup[#All],2,0)","v":"Operasyon"},"EFT","KDV Ödemeleri","Vergi Dairesi",null,-25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":87100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":61},"2020-06-26",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":26},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J83,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J83,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","E Toptan Ticaret",null,-25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":62100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":62},"2020-06-29",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":27},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J84,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J84,Grup[#All],2,0)","v":"Operasyon"},"EFT","SGK Ödemeleri","SGK",null,-2000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":60100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":63},"2020-06-30",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":27},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J85,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J85,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tahsilatlar","C Mimarlık",null,10000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":70100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":64},"2020-06-30",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":27},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J86,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J86,Grup[#All],2,0)","v":"Finansman"},"EFT","Faiz Ödemeleri","Vergi Dairesi",null,-3000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":67100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":65},"2020-06-30",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":27},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":6},{"$f":"VLOOKUP(J87,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J87,Grup[#All],2,0)","v":"Finansman"},"EFT","Kredi Geri Ödemeleri","X Bank",null,-20000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":47100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":66},"2020-07-01",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":27},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J88,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J88,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","A Madencilik",null,-12500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":34600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":67},"2020-07-02",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":27},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J89,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J89,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tahsilatlar","E Restorasyon",null,15000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":49600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":68},"2020-07-03",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":27},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J90,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J90,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","A Ticaret",null,30000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":79600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":69},"2020-07-03",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":27},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J91,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J91,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","F Mühendislik",null,18000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":97600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":70},"2020-07-06",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":28},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J92,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J92,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","A Ticaret",null,75000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":172600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":71},"2020-07-06",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":28},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J93,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J93,Grup[#All],2,0)","v":"Operasyon"},"EFT","Kira Ödemeleri","Vergi Dairesi",null,-10000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":162600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":72},"2020-07-06",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":28},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J94,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J94,Grup[#All],2,0)","v":"Operasyon"},"EFT","Personel Ücretleri","Personel",null,-95000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":67600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":73},"2020-07-07",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":28},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J95,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J95,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","D Nalburiye",null,-7500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":60100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":74},"2020-07-07",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":28},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J96,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J96,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","C Nakliyay",null,-12500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":47600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":75},"2020-07-09",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":28},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J97,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J97,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tahsilatlar","B İnşaat",null,17000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":64600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":76},"2020-07-10",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":28},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J98,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J98,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","B Madencilik",null,-12500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":52100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":77},"2020-07-10",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":28},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J99,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J99,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","A Madencilik",null,-12500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":39600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":78},"2020-07-13",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":29},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J100,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J100,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","A Madencilik",null,-2500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":37100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":79},"2020-07-13",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":29},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J101,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J101,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","B Madencilik",null,-12500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":24600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":80},"2020-07-14",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":29},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J102,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J102,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","E Toptan Ticaret",null,-7500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":17100}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":81},"2020-07-14",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":29},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J103,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J103,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","B Madencilik",null,-12500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":4600}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":82},"2020-07-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":29},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J104,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J104,Grup[#All],2,0)","v":"Operasyon"},"EFT","Elektrik / Su / Doğalgaz","D Doğalgaz Dağıtım",null,-100,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":4500}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":83},"2020-07-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":29},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J105,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J105,Grup[#All],2,0)","v":"Operasyon"},"EFT","Elektrik / Su / Doğalgaz","S Su ve Kanalizasyon",null,-300,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":4200}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":84},"2020-07-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":29},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J106,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J106,Grup[#All],2,0)","v":"Operasyon"},"EFT","Sigorta Primleri","S Sigorta Acentası",null,-300,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":3900}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":85},"2020-07-15",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":29},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J107,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J107,Grup[#All],2,0)","v":"Operasyon"},"EFT","Elektrik / Su / Doğalgaz","G Elektrik Dağıtım",null,-1000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":2900}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":86},"2020-07-21",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":30},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J108,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J108,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tahsilatlar","B İnşaat",null,15000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":17900}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":87},"2020-07-22",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":30},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J109,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J109,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","C Nakliyat",null,-2500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":15400}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":88},"2020-07-23",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":30},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J110,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J110,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","C Mimarlık",null,25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":40400}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":89},"2020-07-23",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":30},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J111,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J111,Grup[#All],2,0)","v":"Operasyon"},"EFT","Muhtasar Ödemeleri","Vergi Dairesi",null,-11000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":29400}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":90},"2020-07-24",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Cuma"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":30},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J112,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J112,Grup[#All],2,0)","v":"Operasyon"},"EFT","KDV Ödemeleri","Vergi Dairesi",null,-27500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":1900}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":91},"2020-07-27",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":31},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J113,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J113,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","A Ticaret",null,20000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":21900}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":92},"2020-07-27",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Pazartesi"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":31},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J114,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J114,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tedarikçi Ödemeleri","E Toptan Ticaret",null,-7500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":14400}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":93},"2020-07-28",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Salı"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":31},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J115,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J115,Grup[#All],2,0)","v":"Operasyon"},"Çek","Tedarikçi Ödemeleri","D Nalburiye",null,-2500,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":11900}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":94},"2020-07-29",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Çarşamba"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":31},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J116,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J116,Grup[#All],2,0)","v":"Operasyon"},"EFT","SGK Ödemeleri","SGK",null,-2000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":9900}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":95},"2020-07-30",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":31},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J117,Grup[#All],3,0)","v":"Nakit Girişleri"},{"$f":"VLOOKUP(J117,Grup[#All],2,0)","v":"Operasyon"},"EFT","Tahsilatlar","F Mühendislik",null,25000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":34900}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":96},"2020-07-30",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":31},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J118,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J118,Grup[#All],2,0)","v":"Finansman"},"EFT","Faiz Ödemeleri","Vergi Dairesi",null,-3000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":31900}]
[null,{"$f":"COUNTA(INDEX(Nakit_Akis[Tarih],1):Nakit_Akis[[#This Row],[Tarih]])","v":97},"2020-07-30",{"$f":"VLOOKUP(WEEKDAY(Nakit_Akis[[#This Row],[Tarih]],2),Gunler[#All],2,0)","v":"Perşembe"},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2)-1,WEEKNUM(Nakit_Akis[[#This Row],[Tarih]],2))","v":31},{"$f":"IF(Nakit_Akis[[#This Row],[İşlem Türü]]=\"Başlangıç Bakiye\",MONTH(Nakit_Akis[[#This Row],[Tarih]])-1,MONTH(Nakit_Akis[[#This Row],[Tarih]]))","v":7},{"$f":"VLOOKUP(J119,Grup[#All],3,0)","v":"Nakit Çıkışları"},{"$f":"VLOOKUP(J119,Grup[#All],2,0)","v":"Finansman"},"EFT","Kredi Geri Ödemeleri","X Bank",null,-20000,{"$f":"IF(OR(AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]=\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]<0),AND(Nakit_Akis[[#This Row],[Giriş/Çıkış]]<>\"Nakit Çıkışları\",Nakit_Akis[[#This Row],[Tutar]]>0)),\"\",\"Hata\")","v":""},{"$f":"SUM(INDEX(Nakit_Akis[Tutar],1):Nakit_Akis[[#This Row],[Tutar]])","v":11900}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2020-12-12"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"a",null,null,null,"a","a",null,"a","a","a","a"]

{"sheet":"Haftalık Analiz","index":1,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Nakit Akış Raporu / Haftalık Analiz"]
[{"$f":"'Nakit Akış'!A2:D2","v":"2020-04-30"}]
[]
[]
[]
[]
[null,"Nakit Akış","Hafta"]
[null,"Kalemler",17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"Toplam"]
[null,"Başlangıç Bakiye",100000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,100000]
[null,"Nakit Girişleri",0,0,50000,70000,25000,55000,105000,30000,65000,70000,73000,92000,0,40000,45000,720000]
[null,"Operasyon",0,0,50000,70000,25000,55000,70000,30000,50000,70000,73000,92000,0,40000,45000,670000]
[null,"Tahsilatlar",0,0,50000,70000,25000,55000,70000,30000,50000,70000,73000,92000,0,40000,45000,670000]
[null,"Yatırım",0,0,0,0,0,0,0,0,15000,0,0,0,0,0,0,15000]
[null,"Demirbaş Satış Tahsilatı",0,0,0,0,0,0,0,0,15000,0,0,0,0,0,0,15000]
[null,"Finasman",0,0,0,0,0,0,35000,0,0,0,0,0,0,0,0,35000]
[null,"Kredi Kullanımları",0,0,0,0,0,0,35000,0,0,0,0,0,0,0,0,35000]
[null,"Nakit Çıkışları",0,-10000,-137500,-36700,-10000,-67500,-150000,0,-11700,-84500,-37500,-150000,-36700,-41000,-35000,-808100]
[null,"Operasyon",0,-10000,-137500,-36700,-10000,-44500,-150000,0,-11700,-84500,-14500,-150000,-36700,-41000,-12000,-739100]
[null,"Tedarikçi Ödemeleri",0,-10000,-37500,-35000,-10000,-10000,-47500,0,-10000,-47500,-12500,-45000,-35000,-2500,-10000,-312500]
[null,"Personel Ücretleri",0,0,-90000,0,0,0,-92500,0,0,0,0,-95000,0,0,0,-277500]
[null,"Kira Ödemeleri",0,0,-10000,0,0,0,-10000,0,0,0,0,-10000,0,0,0,-30000]
[null,"Elektrik / Su / Doğalgaz",0,0,0,-1400,0,0,0,0,-1400,0,0,0,-1400,0,0,-4200]
[null,"KDV Ödemeleri",0,0,0,0,0,-22500,0,0,0,-25000,0,0,0,-27500,0,-75000]
[null,"Muhtasar Ödemeleri",0,0,0,0,0,-10000,0,0,0,-12000,0,0,0,-11000,0,-33000]
[null,"SGK Ödemeleri",0,0,0,0,0,-2000,0,0,0,0,-2000,0,0,0,-2000,-6000]
[null,"Sigorta Primleri",0,0,0,-300,0,0,0,0,-300,0,0,0,-300,0,0,-900]
[null,"Finansman",0,0,0,0,0,-23000,0,0,0,0,-23000,0,0,0,-23000,-69000]
[null,"Kredi Geri Ödemeleri",0,0,0,0,0,-20000,0,0,0,0,-20000,0,0,0,-20000,-60000]
[null,"Faiz Ödemeleri",0,0,0,0,0,-3000,0,0,0,0,-3000,0,0,0,-3000,-9000]
[null,"Toplam",100000,-10000,-87500,33300,15000,-12500,-45000,30000,53300,-14500,35500,-58000,-36700,-1000,10000,11900]

{"sheet":"Aylık Analiz","index":2,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Nakit Akış Raporu / Aylık Analiz"]
[{"$f":"'Nakit Akış'!A2:D2","v":"2020-04-30"}]
[]
[]
[null,"Nakit Akış","Dönem"]
[null,"Kalemler",4,5,6,7,"Toplam"]
[null,"Başlangıç Bakiye",100000,0,0,0,100000]
[null,"Başlangıç Bakiye",100000,0,0,0,100000]
[null,"Başlangıç Bakiye",100000,0,0,0,100000]
[null,"Nakit Girişleri",0,200000,280000,240000,720000]
[null,"Operasyon",0,200000,230000,240000,670000]
[null,"Tahsilatlar",0,200000,230000,240000,670000]
[null,"Yatırım",0,0,15000,0,15000]
[null,"Demirbaş Satış Tahsilatı",0,0,15000,0,15000]
[null,"Finasman",0,0,35000,0,35000]
[null,"Kredi Kullanımları",0,0,35000,0,35000]
[null,"Nakit Çıkışları",0,-261700,-271200,-275200,-808100]
[null,"Operasyon",0,-238700,-248200,-252200,-739100]
[null,"Tedarikçi Ödemeleri",0,-102500,-105000,-105000,-312500]
[null,"Personel Ücretleri",0,-90000,-92500,-95000,-277500]
[null,"Kira Ödemeleri",0,-10000,-10000,-10000,-30000]
[null,"Elektrik / Su / Doğalgaz",0,-1400,-1400,-1400,-4200]
[null,"KDV Ödemeleri",0,-22500,-25000,-27500,-75000]
[null,"Muhtasar Ödemeleri",0,-10000,-12000,-11000,-33000]
[null,"SGK Ödemeleri",0,-2000,-2000,-2000,-6000]
[null,"Sigorta Primleri",0,-300,-300,-300,-900]
[null,"Finansman",0,-23000,-23000,-23000,-69000]
[null,"Kredi Geri Ödemeleri",0,-20000,-20000,-20000,-60000]
[null,"Faiz Ödemeleri",0,-3000,-3000,-3000,-9000]
[null,"Toplam",100000,-61700,8800,-35200,11900]

{"sheet":"Gruplar","index":3,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
["Nakit Akış Raporu / Grup Tanımları"]
[{"$f":"'Nakit Akış'!A2:D2","v":"2020-04-30"}]
[]
[]
[null,"İşlem","Grup","Nakit ",null,null,"Sayı","Gün"]
[null,"Bankacılık Masrafları","Operasyon","Nakit Çıkışları",null,null,1,"Pazartesi"]
[null,"Başlangıç Bakiye","Başlangıç Bakiye","Başlangıç Bakiye",null,null,2,"Salı"]
[null,"Demirbaş Alım Ödemeleri","Yatırım","Nakit Çıkışları",null,null,3,"Çarşamba"]
[null,"Demirbaş Satış Tahsilatı","Yatırım","Nakit Girişleri",null,null,4,"Perşembe"]
[null,"Elektrik / Su / Doğalgaz","Operasyon","Nakit Çıkışları",null,null,5,"Cuma"]
[null,"Faiz Ödemeleri","Finansman","Nakit Çıkışları",null,null,6,"Cumartesi"]
[null,"KDV Ödemeleri","Operasyon","Nakit Çıkışları",null,null,7,"Pazar"]
[null,"Kira Ödemeleri","Operasyon","Nakit Çıkışları"]
[null,"Kredi Geri Ödemeleri","Finansman","Nakit Çıkışları"]
[null,"Kredi Kartı Ödemeleri","Operasyon","Nakit Çıkışları"]
[null,"Kredi Kullanımları","Finasman","Nakit Girişleri"]
[null,"Kurumlar Vergisi Ödemeleri","Operasyon","Nakit Çıkışları"]
[null,"Ortaklardan Borç","Finansman","Nakit Çıkışları"]
[null,"Tedarikçi Ödemeleri","Operasyon","Nakit Çıkışları"]
[null,"Personel Avansları","Operasyon","Nakit Çıkışları"]
[null,"Personel Ücretleri","Operasyon","Nakit Çıkışları"]
[null,"Sigorta Primleri","Operasyon","Nakit Çıkışları"]
[null,"Tahsilatlar","Operasyon","Nakit Girişleri"]
[null,"Muhtasar Ödemeleri","Operasyon","Nakit Çıkışları"]
[null,"SGK Ödemeleri","Operasyon","Nakit Çıkışları"]
[null,"nanay","babay","Nakit Çıkışları"]